﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;

namespace KD.Sms.DAL.SqlLite
{
    internal sealed partial class Main
    {
        /// <summary>
        /// 获取所有物料信息
        /// </summary>
        /// <returns></returns>
        public DataTable DoQueryMaterial()
        {
            return SQLiteHelper.GetDataTable("select Material_id,Material_Name from S_Material order by Material_Name asc");
        }

        /// <summary>
        /// 获取所有供应商
        /// </summary>
        /// <returns></returns>
        public DataTable DoQuerySupplier()
        {
            return SQLiteHelper.GetDataTable("select Supplier_Id,Supplier_Name from S_Supplier order by Supplier_Name asc");
        }

    }
}
